# -*- coding: utf-8 -*-
from db.mysql import MysqlClient
from common.helper import Helper
class Arrangement( object ):
    def __init__(self):
        self.mysql = MysqlClient()
        self.name = "泰无忧·百万防癌保"

    def pullData(self, data={}):
        for item in Helper.selectData(self.name, self.mysql):
            data["name"] = self.name
            data["company"] = "泰康保险"
            data["year"] = item["year"]
            data["socialSec"] = "Y" if item["socialSec"] == "1" else "N"
            data["money"] = "200w" if item["plan"] == "1010A0G201" else "400w"
            data["expire"] = "1年"
            data["payType"] = "年缴"
            data["price"] = item["price"]
            Helper.mergeTable( self.name , self.mysql, data )
